package com.qijian.maindata.domain.query;

import java.math.BigDecimal;

import com.qijian.common.utils.mybatis.WhereType;
import com.qijian.common.utils.mybatis.WhereTypeEnum;
import lombok.Data;
import java.util.Set;
import lombok.ToString;
import com.baomidou.mybatisplus.annotation.TableName;


/**
 * 车间仓库对象 查询条件类
 *
 * @author qijian
 * @date 2024-03-01
 */

@Data
@ToString
@TableName("main_workshop_ledger")
public class WorkshopLedgerQuery {

    @WhereType(filed = "id")
    private Long id;
    @WhereType(filed = "id", type = WhereTypeEnum.IN)
    private Set<Long> ids;
    @WhereType(filed = "factory_area_id")
    private Long factoryAreaId;
    @WhereType(filed = "factory_area", type = WhereTypeEnum.LIKE)
    private String factoryArea;
    @WhereType(filed = "location", type = WhereTypeEnum.LIKE)
    private String location;
    @WhereType(filed = "name", type = WhereTypeEnum.LIKE)
    private String name;
    @WhereType(filed = "spec", type = WhereTypeEnum.LIKE)
    private String spec;
    @WhereType(filed = "quantity")
    private BigDecimal quantity;
    @WhereType(filed = "unit", type = WhereTypeEnum.LIKE)
    private String unit;
    @WhereType(filed = "dept_id")
    private String deptId;
    @WhereType(filed = "dept_name", type = WhereTypeEnum.LIKE)
    private String deptName;
    @WhereType(filed = "remark")
    private String remark;
    @WhereType(filed = "year", type = WhereTypeEnum.LIKE)
    private String year;

    @WhereType(func = "(FIND_IN_SET({1},sys_classify.ancestors) or sys_classify.id = {1})")
    private Long itemClassifyId;

    @WhereType(filed = "location_parent", tableName = "main_ledger_area_detail")
    private String locationParent;

    @WhereType(filed = "area", tableName = "main_ledger_area_detail")
    private String area;



}
